Select the database for maintaining in the object pane. Control-click the database and select the Maintain from the popup menu.
Read-Write
When READ_WRITE is specified, users can retrieve and modify data. READ_WRITE is the default setting.
Read-Only
When READ_ONLY is specified, the database is in read-only mode.
Online
When ONLINE is specified, the database is open and available for use. ONLINE is the default setting.
Offine
When OFFLINE is specified, the database is closed and shutdown cleanly and marked offline. The database cannot be modified while the database is offline.
Emergency
User has changed the database and set the status to EMERGENCY. The database is in single-user mode and may be repaired or restored. The database is marked READ_ONLY, logging is disabled, and access is limited to members of the sysadmin fixed server role. EMERGENCY is primarily used for troubleshooting purposes. For example, a database marked as suspect can be set to the EMERGENCY state. This could permit the system administrator read-only access to the database. Only members of the sysadmin fixed server role can set a database to the EMERGENCY state.
Multi User
MULTI_USER allows all users with the appropriate permissions to connect to the database. MULTI_USER is the default setting.
Single User
SINGLE_USER allows one user at a time to connect to the database. All other user connections are broken. The timeframe for breaking the connection is controlled by the termination clause of the ALTER DATABASE statement. New connection attempts are refused. The database remains in SINGLE_USER mode even if the user who set the option logs off. At that point, a different user (but only one) can connect to the database.
Restricted User
RESTRICTED_USER allows only members of the db_owner fixed database role and dbcreator and sysadmin fixed server roles to connect to the database, but it does not limit their number. Users who are not members of these roles are disconnected in the timeframe specified by the termination clause of the ALTER DATABASE statement. Moreover, new connection attempts by unqualified users are refused.